Adding Calculated Costs

Sometimes the amount to be entered is not fixed for Sheila, for example because she has to enter a yearly amount month by month or she has to calculate a total amount from several parts. Sheila doesn't have to do her calculation with a calculator first; she can do her calculations directly as she enters them.

You can add, subtract, multiply and divide in the cells and insert parentheses. This is possible for direct entries in the grid as well as for entries of amounts in another currency (see Setting a Multi-Currency Value).

It is important that you start the input with an equal sign for a calculation. For example, if you want to add the amounts 456.99, 856.45 and 89.74, the correct entry is:

=456.99+856.45+89.74

Without the equal sign the input is not understood and cannot be calculated.

If you enter an incomplete calculation or have an error in the formula syntax the cell will be outlined in red, and the calculation will not be complete. The box will be outlined in green after you have entered a valid calculation.

Attention

Uptempo does not record the formula, so once the calculation is complete there is no way to see the original equation.

The result of a calculation is always displayed rounded to two decimal places.

You need to enter the sum of the following amounts in a cell: 260.56, 378.89 and one third of the amount 951.23.

You click on the cell and enter:

= 260.56+378.89+951.23/3

When you press Enter, the result 956.33 is displayed.

You have an annual amount of 10,000, but it is drawn down equally each month.

  1. On the Investments tab, locate the marketing investment you would like to add recurrent costs for.

  2. Click on the cell and enter:
    =10000/12

  3. Copy the entry by using the keyboard shortcut key Control/Command and C.

  4. Click the corresponding cell of the next month.

    5. The entry in the previous cell is calculated.

  5. Paste the entry by right-clicking in the second cell and selecting Paste.

    6. Note: Using the keyboard shortcut key Control/Command and V also allows you to paste the amount.

  6. Repeat steps 4 and 5 for every month.

You have entered the recurrent costs.